import openpyxl

class GetData:
    def getdata_Excel(self):
        wk=openpyxl.load_workbook("../report/pass_data.xlsx")
        sheet1=wk["success"]
        print(sheet1.cell().value)

        datalist=[]
        for x in range(2,sheet1.max_row+1):
            dict1={}
            for y in range(2,sheet1.max_column+1):
                dict1[sheet1.cell(1,y).value]=sheet1.cell(x,y).value
            datalist.append(dict1)
            print(datalist)
        # return datalist

